Using Snowflake on AWS as a target
This section describes how to set up and use Snowflake on AWS as a target in a replication task. Snowflake on AWS is located in the cloud and is accessed through an Amazon Web Services (AWS) account.
Qlik Replicate first stages the source data either directly on Snowflake or in an Amazon S3 bucket, and then loads it into the relevant tables in the Snowflake data warehouse.
When configuring a task with a Snowflake on AWS target endpoint, note the following:
-
If the Apply Changes task option is enabled and the change processing mode is set to Batch optimized apply, it is recommended to enable the Apply batched changes to multiple tables concurrently option in the Change Processing Tuning tab.
-
When the Apply batched changes to multiple tables concurrently option is selected, the option to set a Global Error Handling policy will not be available. Also, some of the task-specific error handling defaults will be different.
For more information, see the Apply batched changes to multiple tables concurrently option in the Change Processing Tuning tab.